SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10455 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10455 [ RunTime:0.003362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603574,25969,808792,569956,1003403,830239,101523,839357,329609,814295,742141,867321,924773,494346,446429,847050,309581,1046104,178974,919749,995998,395707,421917,59296,615730,978095,510524,653999,997414,314577,181061,383901,290448,333419,196376,666354,375645,1002724,946389,739695,21586,784202,17508,285453,6143,97382,582367,460704,165294,927602,453531,442478,109367,956084,339972,254760,921219,779879,642170,38218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]