SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521353 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521353 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686898,529709,381926,180536,576756,330096,661869,745766,660031,948564,154945,500352,113041,74195,571557,470679,333890,28378,921837,660601,709132,398736,371172,1040779,992919,229370,357011,1045141,535682,645753,580027,414585,435401,768821,592152,678987,204250,160338,1043946,480131,90170,378134,699142,811503,507489,142241,746830,358169,44634,153574,9669,976627,961784,575462,103666,786810,815161,666400,939315,445123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]