SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336552 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336552 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409406,341784,312233,768340,296028,355257,758144,149302,87885,206692,256989,44431,382938,588704,500649,429630,651102,401491,353710,858531,607836,615621,398901,5532,238151,644359,219402,655201,175858,474107,622118,603647,833762,990367,195907,588886,929475,213664,336710,366154,703727,821765,200550,419182,558429,605903,720393,1041793,522586,541109,572522,829960,1011900,94485,322732,138614,541127,283757,1001357,456204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]