SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031161 LIMIT 1 [ RunTime:0.001772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031161 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699348,472060,703727,191037,771402,1008641,691114,642487,956701,676325,407078,738280,871932,780633,42539,1011023,127078,20185,955415,742299,531272,989329,977469,913565,190796,1041514,365680,65632,429814,564671,571142,656405,42517,765858,241274,435811,676830,918254,590059,762088,980403,219277,133778,1033493,999136,998099,329308,186589,514863,825781,1014642,316573,399921,161264,877838,1043297,69912,794397,739602,775357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002619s ]