SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410499 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410499 [ RunTime:0.004764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69265,101906,316963,877911,608794,963993,917402,981073,737640,1036355,1043603,254291,85217,800561,227207,571917,980700,493966,503710,969277,560556,933387,42163,405459,259271,640738,142383,820540,967466,561435,414978,159442,928578,487974,448871,734178,974980,210607,596763,536531,734203,701441,951977,708818,70874,382534,211360,216126,765773,285393,531648,696056,612913,407365,670548,297141,615613,465875,1008745,1012299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]