SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271028 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271028 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220523,208531,79919,1019904,693686,416648,785658,980896,908188,966583,609949,395983,200242,807169,488821,236913,957150,514084,272271,570178,456556,893722,53590,584801,1005189,4880,117904,908639,241842,603495,917815,995925,121859,695254,824735,405092,496598,903164,516551,214231,1000509,476450,612045,507369,264081,862222,1048827,402651,748833,254803,39687,242869,164031,506655,1010264,1001273,300475,527161,582006,138069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]