SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159710 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159710 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461907,912263,1039735,1023137,551854,215755,934644,232833,854513,536299,895608,324468,579790,744085,517689,161937,285033,643130,511506,1019447,192642,1023349,812083,97419,911805,340068,695973,412229,904247,361106,611045,132531,1039850,813025,387346,895922,235367,1044008,32947,4272,849003,267426,623813,40632,495231,568766,465296,28224,100552,44656,371094,256722,763561,449923,349117,279398,232966,635468,376693,319682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]