SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399618 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399618 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14338,402482,300618,195219,97571,275863,555291,714612,239844,1006810,428493,400558,188894,613673,668773,240440,406449,873600,68927,896112,976906,6010,663709,857843,697479,502451,804810,869118,820370,755641,150550,846352,964819,400580,458529,627423,706888,170577,819606,971895,38051,907731,313852,843166,963776,532630,751410,79726,517339,132220,307075,562283,229485,1029154,266336,1042110,404202,660792,551652,140136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]