SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426781 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426781 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415599,508628,185999,184555,41189,470142,296980,390175,247861,348560,437665,254592,302412,1002709,2981,249987,130111,397932,380053,187133,614977,1001058,813550,1003630,774653,103391,117983,1002799,381078,887707,244196,924360,64349,744446,1003399,20098,423375,819486,427052,532429,1009018,26328,393952,392949,744580,92090,608397,741577,616454,727015,288840,704876,429436,622495,956078,45919,349562,54740,178743,1035523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]