SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281292 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281292 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651718,688118,992542,116434,194288,428144,205481,545009,837585,390587,721028,481542,337063,781476,851632,186674,324314,206024,455444,207543,13514,311137,533545,470584,1031824,837026,376340,121451,1038801,902182,31119,68038,944486,601717,277716,335496,953080,862819,497354,568698,1012169,375451,180279,18033,883242,798590,515299,323458,769188,101101,768020,697177,435505,185727,275965,166154,374933,593884,472676,670054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]