SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336831 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336831 [ RunTime:0.001137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991706,109389,294403,623422,791394,22206,630047,136928,566992,1041465,1031713,295269,125278,561665,812123,802184,512673,412340,210705,519074,364471,530069,654008,216460,411972,498923,426529,293009,297164,347576,106421,820854,852076,522854,1002340,262485,749803,814579,939875,280152,964505,217184,5083,743997,417818,951315,596308,518438,554945,332168,138074,146375,140768,354783,202045,34464,827046,335670,202508,404031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]