SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468508 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468508 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579023,113364,1022760,295796,171794,988936,351680,37371,1021412,723867,754857,152897,1040802,351367,330348,355150,612421,253969,312475,310068,303460,683977,288665,218224,98740,452276,159191,565091,705066,620598,1009435,441514,708648,266454,797755,449073,681927,836996,396193,330234,532030,1031419,260432,228540,361743,726897,991125,842959,261605,93420,382666,40755,934678,104554,663949,853168,289511,255820,601465,674541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]