SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005796 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005796 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390532,229923,88984,287185,332598,291154,335228,851307,939490,710714,791528,302690,406252,778452,64561,646400,1012926,233866,938654,25166,883413,916084,544455,589733,187060,509857,789399,1031379,39520,21152,999106,835495,710192,418281,477179,318806,153499,865044,60204,624619,126624,545831,277730,694233,23170,670015,625515,508800,1033055,1026443,680213,145479,508,725760,365979,448425,852356,159382,559185,583074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]