SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038986 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038986 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031938,854963,538818,686994,871378,196457,257334,34418,272998,399342,700588,78931,183212,757987,866673,781340,13657,773840,433064,859473,33344,802617,962404,764799,548333,4506,233330,696062,582729,768132,800523,126591,908799,620969,181256,275019,182528,988769,510248,257234,90780,984187,784011,633060,445970,945624,885129,219135,956578,658189,893095,882602,175357,715292,144521,38811,515867,1024363,779803,617182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]