SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805928 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805928 [ RunTime:0.005116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737856,745659,557536,431483,979945,395405,222992,865408,551899,157821,391398,471359,699413,484409,446200,841779,119999,29823,570378,430863,282242,450394,859861,772974,531538,1003674,35222,443737,342317,597236,921922,723084,669483,352746,53691,635243,662120,546486,103479,813710,492017,1020982,189542,68889,265568,317163,234441,771751,475828,140261,517827,879751,228821,365806,611020,127290,252588,823599,600696,220939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]