SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 176118 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 176118 [ RunTime:0.002574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308141,734862,881863,897942,492465,240210,392074,38626,872081,285424,408157,619041,374880,477820,1037071,888658,534056,940047,908905,331206,192753,998110,884730,384210,402500,228416,72583,1043171,906492,898203,481807,1029515,501267,676439,588396,1007165,428801,188764,839596,786092,519357,74763,146421,1015916,215965,939039,533024,364643,1005194,649586,632918,902532,414191,900588,439374,1027547,594090,780120,786409,530837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 176118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 176118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]