SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403470 LIMIT 1 [ RunTime:0.001373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403470 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896069,904988,277867,607942,397736,824755,911424,444046,974646,39605,530390,652447,214738,17286,478587,1025159,1048328,350347,358523,480313,593361,647257,134786,508277,147714,713771,171391,152642,914583,758492,641237,582487,196769,358681,271668,847943,100725,1011239,1013997,589357,1018473,434171,333662,948588,803169,454258,14269,735830,371354,988184,981235,178629,296873,894189,330293,370462,186472,86229,655049,854116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002281s ]