SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010843 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010843 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124826,551861,241464,832328,413225,976776,197332,121895,922878,673339,858198,264650,912953,963779,442515,362380,268581,980327,236987,914117,252163,679533,347313,430021,108233,659649,61038,243540,810581,1032828,138195,840429,731476,277737,313738,381655,946632,867565,1008722,740315,962772,439489,13054,817819,471389,495875,517062,911813,418064,321775,216082,200464,383874,1018439,33661,25663,957563,512207,1027248,259853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]