SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2680 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2680 [ RunTime:0.005596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991302,188534,280772,854984,11862,334979,516860,616307,253510,1014215,405305,141825,470225,157907,76729,610634,793485,264731,395461,261329,370893,608585,251360,260510,435826,428266,608804,368724,1014779,749045,779058,298937,196342,446447,597679,59984,4080,421982,769923,856932,986406,10885,810736,948901,13231,495386,76347,707255,554687,36861,291154,363651,771755,453280,1042144,237081,968882,398881,701670,21041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]