SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245051 LIMIT 1 [ RunTime:0.001864s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245051 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429555,743392,334410,849334,708709,767990,868234,497887,562611,391230,599626,959833,144505,684703,668894,382624,394653,374246,510701,371571,691842,53146,950058,861998,723514,907607,793293,941300,580713,629082,774030,145732,548129,102630,1017806,316570,326089,309190,359662,736989,460653,866990,223834,712395,831829,267511,248833,235604,308269,24145,544157,273058,420110,221291,129665,909255,372071,936879,1019902,358520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004597s ]