SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539039 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539039 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976700,516667,1017098,888250,71184,1032068,692503,409559,766595,698747,436877,926771,1017516,658058,954878,1042379,647947,158565,230830,354624,1015212,481732,354128,266029,57619,865939,1013688,906426,976086,757330,754845,406588,682379,318889,415982,937990,1032967,317619,516599,683710,534636,916025,806392,85236,384464,164480,582721,294761,882344,174363,688494,235956,655979,736236,455190,785325,117734,255878,183769,406249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001419s ]