SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476743 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476743 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955618,990580,51354,156904,749584,649850,865836,356911,362802,1015307,43300,288598,710324,813903,373095,571021,18081,870909,160492,570919,752369,917747,481554,622209,298147,624033,458156,924891,1015150,916596,593056,786965,822860,317231,80686,683564,738048,842402,566153,988394,541700,179506,350552,623974,100030,797161,212805,551237,489094,237575,499799,640537,789037,846866,677888,973875,42759,29766,167278,535062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]