SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012524 LIMIT 1 [ RunTime:0.001031s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012524 [ RunTime:0.003937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334117,894577,943898,683484,134408,290506,866860,301007,53500,467100,313826,307007,664461,888665,798269,296306,408465,446946,848135,74493,140565,1045205,717347,71437,148386,139668,111968,327711,905934,751453,226574,246397,723436,533834,462467,376026,361563,544685,399752,237544,87669,1024538,46834,276200,318590,365015,134311,113645,781785,759194,1023055,616980,126187,662804,280149,768396,550772,545160,763827,619529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001790s ]