SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510709 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510709 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487992,1020142,327687,439623,578794,703963,888794,511589,330959,188040,469188,442547,6267,686838,897513,201320,248680,893373,744005,225002,754802,552241,127269,8175,457788,1015365,65873,344638,515365,761200,667648,112465,117459,375668,585533,535007,1040412,607704,795287,209539,798837,875317,148185,513957,530867,417449,397108,255857,45548,947906,997542,263887,314121,685657,225658,112976,372131,161444,566081,62489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]