SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 165364 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 165364 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146938,621623,614921,190119,26835,952788,698984,2136,815750,586918,755549,788187,1035257,866809,676505,993010,685253,556947,15148,582532,588563,576688,135613,456943,364506,455551,36964,371844,40627,800426,604023,108052,424655,608799,985495,296448,726502,333534,271850,241283,693267,586556,895747,386479,69288,934543,600463,104359,802799,373990,611897,439322,925174,655588,830825,450124,1047077,129820,939564,765328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 165364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 165364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]