SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426034 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426034 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310318,865578,964242,868857,992956,385530,562511,324611,541585,203152,355531,875142,123438,48540,391378,1040246,870043,705469,416207,252617,107280,726565,418953,348275,1029202,231475,407536,429292,488080,826775,677543,27165,1027397,553465,1005392,114297,569088,187670,671295,207212,556155,750538,707124,323556,508799,26797,908973,240412,40112,100856,587564,625781,761395,834776,730176,12514,451389,15722,71417,79671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]