SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402869 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402869 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922966,558197,123355,965715,874662,595640,788788,537714,952398,397984,505822,376452,487780,396854,490946,864261,511143,863201,26744,256344,862503,939954,202680,126565,39878,589588,1031760,855080,329961,819026,78562,714878,610465,151666,601538,786898,401618,654935,249666,94939,623923,751766,190587,413582,812516,459988,1021289,533433,494879,477340,410952,121249,357095,196712,302863,168860,161202,31597,72780,265544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402869 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402869 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]