SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200628 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200628 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963117,832391,243630,1023725,638913,656109,950088,701234,329165,213227,247577,77093,846771,603699,730971,269553,515847,572320,9264,26891,130513,741042,802282,944523,62350,316352,65483,868603,531667,962806,897629,468429,53099,774127,351825,995549,582052,21002,982238,281218,711124,43293,641456,557780,842075,1000801,784304,573671,932999,725472,279647,126080,205364,425318,845674,869150,481836,591194,257949,823053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]