SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017853 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017853 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574282,281956,1039316,807660,2971,348947,187719,642138,244693,478271,361943,101078,874762,763802,193675,508454,83926,729008,336676,52955,160962,469258,1033218,942813,879731,507424,927070,13414,489024,760460,507680,67082,17182,734720,853077,248762,216981,52257,939555,774841,187591,184632,529831,720628,1025234,404035,701992,429988,777538,653292,901670,601745,428562,503858,511316,413098,249495,988231,63006,798474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002278s ]