SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 990504 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 990504 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178395,265016,165914,112039,804091,699008,334120,371540,312383,154152,978548,1037369,504352,612739,113085,604702,273927,612093,307210,671332,824787,511136,912561,108630,639794,464867,1029062,248443,301807,660106,684230,808470,747531,128100,439590,924502,273650,375045,13514,383992,256088,888663,897357,986348,955763,679225,435657,622245,668049,183718,1030108,262693,986553,1019732,327497,697889,795489,681404,27952,585654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 990504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 990504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]