SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 816907 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 816907 [ RunTime:0.004214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006411,550539,971256,318128,662776,1040133,548486,768907,373493,695016,667281,110002,968107,905692,257533,168041,782840,796220,110887,982344,621736,918451,899372,217295,976589,411299,911400,276320,145590,778036,279477,126055,886556,249121,49968,975076,957001,603636,583837,615047,1003162,965252,220830,823724,342938,297492,928494,334071,208666,250903,500043,1010471,20797,140499,725088,82727,121420,489304,252274,899004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 816907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 816907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]