SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535569 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535569 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782690,100888,108860,582209,423101,355291,155013,1000726,491750,865589,168211,1017735,266272,259014,734564,84845,287035,1013381,1003847,360825,983165,319084,953595,51172,616725,153970,967508,997544,467085,377091,1027497,930674,285994,386112,201122,91791,157194,878714,338644,143855,424566,641030,384643,200545,509124,348883,399557,389051,384411,1041825,616290,377398,920275,952968,142502,474223,967055,235004,128489,1017244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]