SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393419 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393419 [ RunTime:0.002921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528035,106249,120315,747874,917490,41508,585150,635653,226004,811429,824445,277331,862522,159077,156793,752538,540918,337175,842399,222018,346188,351347,263275,60174,1034159,50359,455766,51726,217080,648616,1029295,509191,686982,140611,101232,656527,283108,993023,992246,76798,621792,495097,920009,927656,59085,670222,128683,904125,983649,402608,982423,282160,769953,150105,665189,135013,1042433,668163,784654,54647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]