SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104012 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104012 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736615,520088,987115,602849,484561,815179,859095,315547,948533,815422,137877,323230,845438,370259,858705,895788,154427,81961,112149,501456,115509,999386,959843,675373,448826,245945,451904,567018,907502,886310,846497,392295,860126,90638,265617,287191,232456,249653,49486,26163,816887,316222,148510,776226,169461,48017,183408,986266,573858,326635,246487,134516,379143,250093,494769,833932,582055,561425,450237,558661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]