SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568254 LIMIT 1 [ RunTime:0.001154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568254 [ RunTime:0.003406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17595,219106,307012,55197,852293,992130,559311,268326,1008756,157794,661754,3712,657940,910694,308216,685326,238926,579260,667560,927740,1018508,272389,440199,361685,89357,532489,946144,439381,225914,332869,401256,795505,949285,927184,532736,705273,469792,42669,259590,231171,341911,679291,538762,303565,650135,855792,213388,795187,752955,395495,519742,535422,882095,1029488,776623,19056,279869,880080,571834,974436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]