SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249434 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249434 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422372,175840,1028527,348322,922682,563125,319467,942623,988035,780939,305669,143731,304253,577836,222879,697974,635198,532083,378650,626346,664479,524157,580979,842808,953781,205046,1018807,327875,401324,103199,975909,139690,487282,73944,980332,976123,809955,95267,989679,484552,842046,735239,203762,729492,409775,959376,343999,39059,96044,879499,583963,734121,319073,440582,238168,580497,114329,331588,28395,921905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001748s ]