SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313604 LIMIT 1 [ RunTime:0.001316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313604 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867210,454671,707498,560569,222647,15019,298142,132522,643216,481803,838846,912699,701450,1017805,316711,702319,232497,299677,285898,839843,425475,892287,220358,882978,110585,708335,950182,281420,354839,388274,80414,27043,943943,379167,330797,661572,574861,593616,257280,90613,461136,732277,1009565,182409,14086,205738,258410,42216,140853,341402,441900,920911,978290,268408,315450,433420,736558,469186,827588,857029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]