SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920505 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920505 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624460,750125,931632,283594,1033470,983840,648405,449966,35581,182396,156073,293768,378953,199038,567696,714241,984814,373860,210372,824233,94905,843259,156565,363604,714036,372008,1041742,70591,791331,52808,900169,690840,1033220,873247,239631,253165,1017640,863298,677119,451514,385371,628827,796579,969947,544811,275259,318063,485249,447939,98713,200155,501876,390712,819484,437150,919445,623201,967680,842517,301026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]