SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56608 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56608 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320417,184985,452151,343078,1045178,177967,597952,567555,654823,17525,214837,243481,137127,645830,273944,620600,853884,917122,29023,871323,240806,365289,532395,751227,621714,855774,101885,562586,1035124,511694,1004505,1041791,716225,153885,565049,172474,835809,525895,845052,972804,684527,471232,135191,993567,437109,198190,1036518,620746,446864,373730,807235,930640,407446,388394,606141,591056,19596,665624,497631,485364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]