SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405479 LIMIT 1 [ RunTime:0.002048s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405479 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575042,166730,410467,782698,728536,808984,23226,375959,287506,319349,195203,552098,45979,23460,15390,954944,147452,895742,740381,530880,375837,617252,565768,840896,924274,806903,450162,615074,667439,900498,331998,555470,162521,462760,882575,810733,307193,469276,505314,397115,11493,289447,999096,1022636,766746,260005,896948,639660,408016,320344,871568,16466,195992,496545,444451,403336,514926,618053,16568,335497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]