SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 278616 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 278616 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142746,395158,824324,218994,1040084,1011994,367180,1029768,104470,435352,897400,988732,425840,348324,840973,521112,838335,559091,40350,77282,629695,848979,172122,986141,255660,889756,295719,584073,317111,798383,765130,548110,524345,140071,332132,154863,130178,478247,18392,734634,101720,385218,891751,304138,515766,651109,732974,52301,744347,450239,726792,890218,423761,837801,314463,277530,934680,13212,849062,303542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 278616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 278616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]