SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415529 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415529 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492632,233202,212037,162121,859521,387157,212409,1045372,711714,821584,228656,258044,894254,1010599,169886,267735,426421,279679,772591,644715,114513,614885,307774,196805,239046,1007927,550570,632614,769317,300499,613793,940574,906816,550574,218430,906423,214537,476585,316429,982671,131368,133419,684905,375450,446875,491373,812991,565185,158453,161377,29263,104990,643634,168636,9928,398689,993785,794255,576082,4667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]