SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312029 LIMIT 1 [ RunTime:0.001221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312029 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127387,681716,1016310,289134,475348,130936,410136,40916,782233,701763,1019748,335732,649608,693472,139257,258713,636784,971897,37172,193916,1033264,460327,1035711,114625,911676,881498,943956,905633,278783,1000133,978404,861702,93947,952013,319001,641645,212682,583830,513102,147669,993606,980624,158995,821518,417086,560629,90411,174860,1013369,996108,705820,845399,532494,19508,244087,1038798,1046487,922415,618421,967053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]