SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413103 LIMIT 1 [ RunTime:0.000963s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413103 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023367,1008283,722821,652681,214456,285997,225383,131710,848664,708591,416683,1037264,180874,565716,1016622,563899,443064,1025777,528461,417081,820239,738213,744443,257193,372087,364561,910862,1013855,173079,791467,401951,824529,553591,947960,358140,1026633,139186,720801,173490,104378,898786,431191,124122,921609,314047,326024,1048689,1045841,1011330,294682,260912,395809,995241,177487,929039,186367,207152,95713,870671,917450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]