SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540741 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540741 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200197,435521,413819,380384,633170,989775,19573,119491,245625,703477,616481,315863,690166,88802,811478,842601,910460,659965,618097,308867,442424,64976,874715,826972,779957,1004806,540959,467668,81803,595455,255992,555675,852140,881045,705573,339908,350089,587139,589,505843,565754,78884,441740,724230,650783,861705,663576,114105,489878,912714,752702,894896,435545,464202,620887,625480,467616,766374,765812,666180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]