SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047735 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047735 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439156,466398,1027323,284987,961301,958447,437068,424211,588415,324124,67444,900868,49156,961167,548223,872638,543845,504534,495309,170222,547765,1025938,198953,686117,989822,516778,146878,560830,600603,43505,88219,784381,49875,187672,290697,969633,978141,1007038,435831,209385,475460,780026,538739,329196,579802,1014145,1016266,304330,368155,392051,374927,855826,929665,345549,693867,498072,678510,857191,1026344,268145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]