SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402493 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402493 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265019,417154,708814,336366,82466,661011,563787,6331,80569,164449,398875,546256,706789,459504,722190,706505,643450,986502,890790,1035499,324685,336667,252947,732883,421191,232864,141311,918882,1000691,748889,298738,264234,468807,265798,1011489,400124,372500,181772,571936,123331,359430,391118,152762,94075,641976,995492,891469,996129,1048742,199666,597783,541745,426652,547785,492991,551693,325304,95647,583842,32484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]