SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500410 LIMIT 1 [ RunTime:0.001633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500410 [ RunTime:0.005166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496330,235377,4188,609004,109938,553089,109217,1006791,41963,248128,274769,233806,538268,132865,225367,393908,954712,761400,161131,467306,790258,457001,558818,1042264,532068,1011951,552935,1026413,263166,580540,222508,308591,932842,123036,106691,841637,858483,402054,846628,157374,4987,565181,53744,45308,892684,734361,833065,15717,1041077,132736,618731,796005,1026808,433443,889657,754770,535045,429075,947365,888158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]