SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10103 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10103 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752007,182465,738378,605925,638690,571828,1038988,974727,660549,864647,377837,915145,390582,808331,407155,221474,719531,152542,749668,666999,880007,1040618,867703,482028,827927,702550,850545,256764,705876,163827,382840,930193,549004,731513,847977,23468,727685,162891,795095,334097,456367,471341,691762,618722,135942,140857,528323,130956,356324,270028,725069,1015889,788439,900424,989673,506250,1047283,243265,721741,1046780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]