SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364560 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364560 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326127,766180,979269,661873,43409,629401,95115,57368,606244,720459,321814,953095,316281,935733,263168,381917,232791,345913,585453,822805,1029220,1006887,111207,242749,76795,227342,325747,522538,417846,615502,240955,1025055,412909,18947,768095,704318,483045,32162,138458,280585,656958,416432,460884,175686,483128,319387,101779,380379,659243,243217,602697,506781,649290,742252,439242,819850,796322,446197,1013790,299742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]