SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505899 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505899 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926874,963830,1003174,511639,139991,201592,107741,681447,738561,849237,9173,436050,280918,479236,827451,24019,785239,431369,423787,316344,24503,424855,975474,524855,918008,669859,938887,88909,591821,190911,587703,423999,479772,773170,974264,628478,728595,254392,1036082,956767,617857,330646,705078,627279,934064,663043,73911,262009,950383,966496,1018680,432288,316571,809856,885833,914510,373601,1035355,247164,924503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]