SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250410 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250410 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429307,129318,770303,898186,538518,24467,1042668,837440,82194,816434,973488,291548,676520,36063,285323,987074,543593,559278,986599,1035229,431199,148563,622735,175126,347970,150054,228257,794490,44793,913481,13434,754510,951630,161837,452430,231533,682428,592359,631206,853206,858049,210817,563054,103289,723534,349648,154323,941056,224648,115397,224117,232240,179328,201708,404422,258881,929364,133178,1024606,540388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]