SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455035 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455035 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537648,366415,824811,536185,414584,726687,1016844,490427,715335,672085,867534,829488,818699,627170,1042719,835903,279202,643780,430411,889101,901308,219847,875319,627731,915630,687418,519468,77133,736771,919312,666268,104541,810473,265018,15309,94976,460878,171137,434829,419727,827603,672961,488992,25359,792899,755584,134188,664608,812961,466063,4262,824976,190186,356790,786790,392882,635794,998882,1045774,557090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000856s ]