SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336939 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336939 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250796,70595,197767,696458,1027473,513837,719256,111577,698693,250964,842725,195409,622111,174330,273987,117240,294788,788016,931598,412612,175288,398157,132593,927299,1040406,999187,523647,1041137,371939,1028084,742102,261572,13632,277017,203977,329410,370400,165921,359090,984314,59479,242513,63918,594530,1038468,954360,227915,803009,985493,814328,941540,842398,28467,115397,415979,1018463,979226,762854,926583,648976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]