SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023190 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023190 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048481,431290,50754,552769,1008774,472018,151637,883393,447473,25780,1047527,231067,859818,881228,9611,529172,566514,783820,169806,204026,747102,770353,533685,701291,520268,357424,751309,724586,633181,408567,187179,835066,177374,823332,479468,235280,1048264,356583,468102,450745,7140,432989,118042,456721,901512,540123,444582,213370,967542,877139,783210,965011,335561,644920,35137,19351,219110,360135,696899,110639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001818s ]