SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514332 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514332 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412093,227761,415466,143555,140946,922548,432692,955611,98017,586545,968163,195309,217798,309645,32373,71887,454663,836662,517067,994282,117750,979253,129049,658489,25222,627133,1029828,826555,453540,132797,146490,812270,547413,808771,839464,467087,169999,7849,458800,621743,764501,425147,1040139,918399,409348,800299,63942,977162,115473,435856,631269,717414,306705,803680,667318,584990,705781,957023,1022236,1022780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]