SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534624 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534624 [ RunTime:0.006062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026605,108008,316236,316597,679122,848605,802899,448987,232912,642666,275625,280095,846464,244185,105104,817130,300978,995726,51073,304470,307588,81651,196559,457355,579404,311721,790270,215989,1025370,635111,583068,70148,229377,672434,1681,139354,269732,188076,502268,342723,235685,121882,570341,509120,1005254,146721,145961,672244,201656,929627,864251,185100,795253,786414,353846,137195,53238,149527,53205,649046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]