SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036680 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036680 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221657,142255,459783,244009,812903,805390,537174,679415,28760,379401,195218,163848,501078,313670,475208,167431,255832,537872,706037,944411,504890,10795,779839,676726,755988,124875,359970,564807,272951,373050,764984,426841,411704,230890,989008,132783,548743,738978,437754,58963,906354,965569,848403,448545,352882,854705,423487,528721,272094,774652,671785,281209,919663,78604,1001167,564456,696193,793400,43390,501516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]