SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043326 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043326 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329103,696200,68667,979462,913619,874518,733174,744842,33424,493545,416404,168869,456202,361481,515101,723438,67924,409205,197076,1005144,309989,99015,43908,575055,322833,578496,359032,495209,795962,34947,501479,983124,596415,775583,381227,237340,444016,986935,875490,636734,314959,566640,587480,265927,943579,361035,365877,237535,849875,774365,633623,200792,393346,234337,75915,233464,159596,590777,1029838,340867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]