SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468014 LIMIT 1 [ RunTime:0.000921s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468014 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991271,1007754,323762,836601,79989,648375,943114,842152,875455,150893,846643,217849,608730,268935,283081,651801,647935,702685,688771,309466,191209,551770,23979,84275,420935,245744,241072,451481,144908,854641,593205,539784,1029344,69848,694922,555457,527015,25578,362879,593438,11873,1014419,717810,472219,842083,830688,794801,518253,139157,1021226,891884,600637,353933,899585,519001,676598,649731,949540,1001098,384025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]