SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501513 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501513 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984785,872133,152220,59867,103260,50133,167003,673661,186951,328436,324445,177728,704473,417793,697521,807337,313912,1002681,1033808,394613,221994,221183,163825,756839,194283,526312,736255,637221,1008316,412848,119349,432024,835921,453243,299540,975615,281409,764785,412943,645966,587514,104855,922445,697333,953885,135722,897058,92814,285796,862836,135757,78764,934756,116128,217908,646741,938603,28558,481361,646028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]