SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520300 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520300 [ RunTime:0.003639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225367,926348,492674,497022,130154,884744,104833,433814,603906,24973,752494,708852,1022964,31074,589543,54460,16406,1033133,937466,316548,195051,933965,451750,244735,716786,63507,873930,819179,32968,414634,9944,40623,36867,926952,314817,212257,500668,799572,321546,708076,1048665,995936,188682,396096,298730,146790,457662,143582,111056,320141,992305,242222,733148,664741,947396,986617,319976,1039679,311273,432746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]