SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535890 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535890 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966277,174970,530965,186167,297201,29602,603592,337343,197956,437735,211083,154814,425753,623363,983689,976173,109998,933085,453704,881599,456689,727343,376687,910911,883093,765000,671818,869487,24765,441055,696381,208961,307449,25198,123755,532931,558403,67251,463201,153927,1030021,502167,436661,831947,561993,414774,933179,174077,941572,999737,945380,225271,464146,937890,1025732,423840,642360,740462,941238,528733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]