SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544263 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544263 [ RunTime:0.004677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293780,928802,390323,333891,1008424,640689,658706,452887,80862,54797,677868,519172,814679,231943,668530,80407,901085,838136,698317,791279,233709,410820,721975,2082,998763,482477,902747,417740,375268,428649,208485,740251,1020072,493444,632681,995776,904204,730833,472526,973544,1025318,402575,468648,959346,819462,698013,544065,854338,365468,502930,600114,737374,987692,65729,335783,300884,564439,523591,311409,134493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001675s ]