SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405110 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405110 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546889,796643,864722,327653,632609,557950,422591,968091,75884,53970,483873,631533,946834,419617,447561,986660,515286,477100,794458,335296,318385,198872,949772,478614,924065,974763,679702,228640,66430,758616,7522,955903,222328,678752,401692,585035,931986,783554,489622,597626,446822,967639,344658,752540,20055,673735,379436,731081,335350,501757,269249,505607,378880,882837,534249,31381,193084,537797,938933,524946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]