SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19348 LIMIT 1 [ RunTime:0.002256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19348 [ RunTime:0.006758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258115,29686,989383,846448,109062,873485,155141,185393,193232,589228,727071,677042,430436,92678,131734,441982,256921,307116,575824,737436,526735,590726,371795,23862,671396,38424,1030389,992955,918345,855451,150783,61845,272382,315356,437445,292975,320338,525256,439355,506835,727012,154195,868018,695984,540700,875398,622823,748355,436537,462194,29035,715692,832394,487407,682816,178525,1047530,35946,827717,673552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]