SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424689 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424689 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473102,715964,447991,124463,1006629,456428,209633,720446,25371,211832,341805,488112,809624,1039646,1021343,736979,169730,422645,546816,693271,131642,653984,480782,810520,815578,889918,555679,410272,385879,97412,1010694,381579,942710,885883,5462,494908,179097,130287,562741,41995,444185,119646,1022816,425594,340376,284410,134141,1018239,103943,6515,990872,844484,873095,854836,895462,249480,786986,874441,647907,385160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]