SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 86573 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 86573 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466921,56761,587995,414882,883488,140467,605175,430096,93145,315864,735646,853292,1040410,587721,1043334,1001972,1026231,143853,428171,802046,397198,1033059,1040617,646358,1041084,978763,179729,112315,356118,1036548,208639,508484,846938,1007230,262779,759968,1004509,714816,204523,162587,163972,810620,1039792,979110,870677,968002,1041746,445648,193073,664038,380173,787885,698765,310179,868046,721692,937622,555556,275365,270810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 86573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 86573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]