SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575340 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575340 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96243,1032506,670850,801532,319313,1028549,434815,401789,445370,866096,255659,210018,377658,132796,786920,671171,26310,1008645,141771,400380,247280,228506,515492,499238,609792,373482,382656,558130,410676,436557,25215,327799,907159,374054,118185,35187,906132,289031,207719,224200,779696,297301,112165,989431,170419,686162,507017,1040672,295160,1026684,996624,193528,343172,685917,84254,695736,576247,533525,414575,233015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]