SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474308 LIMIT 1 [ RunTime:0.000777s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474308 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417261,457036,478229,659014,699358,344249,709685,297449,965435,839580,824913,1019691,769177,1003450,741962,582781,609039,255798,149286,263144,398211,310509,57166,968392,592712,480969,366,756396,67499,765620,63658,432932,28649,89118,493609,749458,790500,303192,521877,140535,799589,754263,646467,156241,355035,39722,937623,326607,494962,514288,919524,17593,103301,193189,116771,429881,797475,479102,120093,210988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]