SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046963 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046963 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882182,56992,639476,756670,570453,351178,130224,874274,238208,916134,350320,944627,807865,854799,928788,640026,41227,763280,816999,973151,645674,397351,1029244,912896,13556,946004,1006433,660496,605946,743550,239830,1025740,465657,409575,476757,355751,1015395,488538,547368,971062,830305,909382,956977,172066,827019,792632,934849,9511,334513,890118,727264,555366,579780,476931,299612,78822,201705,334195,460542,459922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]