SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019563 LIMIT 1 [ RunTime:0.003920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019563 [ RunTime:0.004335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819501,335068,937159,226031,964794,509730,647717,426343,409894,910469,1005447,618327,775219,141536,424635,615593,503302,650961,771295,706094,791535,731091,883845,246715,336495,198495,103576,870757,103027,230851,354679,292514,962928,880154,377038,430958,692639,426594,903895,751982,610924,134271,288437,1048614,434623,753937,821397,302075,1038433,188586,580591,807455,122048,678106,600430,547987,38185,371540,810109,911729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001777s ]