SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141015 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141015 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007148,105384,107047,178969,101268,833905,384845,19706,410797,580552,293720,462997,1021501,994614,484198,134471,925236,22910,522849,115489,940830,926801,1028310,196823,468099,366212,474535,281800,464038,847824,983211,713861,65910,905109,1034849,818213,1038317,556348,266630,181013,208593,417369,930756,953324,658201,817321,372970,56839,562662,366597,309788,51853,753809,1037819,513865,217783,775279,350283,739513,768970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]