SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311090 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311090 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354348,742387,585502,268138,773821,922901,215454,104978,564544,350246,326182,996504,121513,31060,779838,980030,373985,629960,1002107,64939,296257,745728,859871,629690,692164,883761,1037577,483279,162664,1006227,820458,705996,206119,798148,172579,893392,51069,63923,970738,812102,164538,325897,1007634,939834,646115,658772,202343,783335,855141,520533,50831,664373,433932,559682,160738,492543,248248,536459,622780,24182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]