SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402684 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402684 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319091,350403,416017,615677,908610,1047192,200673,736299,9695,1041263,435161,908773,210696,157374,898319,218007,242359,376865,329052,734950,432344,915594,875110,162748,616965,778488,307758,690354,496675,361705,488179,433466,631464,398902,813762,91304,716096,554258,392028,915902,99263,913721,928279,182947,804951,111036,291873,947778,835951,1047153,611869,101596,955975,853973,166994,663880,512965,944447,893089,277166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]