SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502013 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502013 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592606,70702,268318,249691,236987,808044,474362,883548,124873,718367,1045524,770366,294213,728664,658599,894926,827301,856559,105620,571910,836566,685142,234873,302915,913328,801932,931729,928289,421540,84727,811881,874638,459135,734393,382839,584934,518446,947650,895036,316946,241499,364556,192238,1010774,394180,237523,890761,722059,919730,779100,784515,190860,495483,936091,441318,624898,638721,280939,721676,867779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]