SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509927 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509927 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805060,883953,1025168,498074,432941,163015,681930,124127,154104,1047937,335838,63697,60914,361381,84927,743648,735746,398607,287257,901355,794286,1035807,538595,994394,602503,398852,12001,361138,1022887,390335,425618,150372,910611,64551,66724,423239,58235,435949,282957,527510,807400,201672,756718,133159,496277,946798,285183,174505,263059,667305,611769,655495,480903,748117,722792,883525,458299,892211,117035,842553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]