SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027840 LIMIT 1 [ RunTime:0.001396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027840 [ RunTime:0.005675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399970,595886,96949,128428,1042928,453325,602897,907460,428957,920890,400855,163329,966405,450622,356243,5120,633382,906554,592623,848994,285409,827172,887497,745309,503973,757576,102937,713993,308691,698342,471083,471925,130711,490105,358491,73537,263557,46680,275183,171550,97569,381456,986404,521612,387161,891140,618258,549710,262007,386120,542720,898298,753096,464897,1007012,617293,341037,539030,253477,670859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]