SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505427 LIMIT 1 [ RunTime:0.002022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505427 [ RunTime:0.003645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755614,136002,25205,890450,934405,344277,307392,524573,743234,312761,177819,414128,275366,415050,317802,801532,690277,811907,936269,834148,277871,158510,500467,234927,360704,110458,731217,443967,279637,886636,871350,784059,489374,587021,1041853,411924,853168,493149,953755,454941,51160,851554,505667,761368,844587,897978,190622,67993,439705,1046458,480460,739614,989398,311957,961713,597993,940983,638396,537291,642076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]