SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517826 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517826 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259057,68208,1024452,125879,485055,473420,156501,3108,809632,292447,740027,440610,658182,408162,451639,229982,139159,332012,983690,957983,45015,298816,522298,934850,511629,600045,470369,123973,670836,140787,529045,886668,917916,574993,33837,369567,976438,565945,651570,346570,421138,465304,429389,173091,675173,291568,402693,1002897,987879,380392,334187,534663,594710,425635,720186,470496,95811,748422,87829,451737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001925s ]