SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533899 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533899 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203363,482573,87599,226293,335442,967173,983744,36285,738601,516550,543010,772334,717624,551786,303525,876327,66619,747705,884231,200862,1023964,267617,741185,454442,415319,667926,922252,922789,124757,263815,407886,82651,544464,687959,110023,894640,605399,639557,327444,113281,1024637,163385,859958,477844,849211,49833,422193,428506,404424,1037624,176756,279763,664925,684542,180168,160911,261566,762398,820349,736862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]