SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197828 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197828 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453027,250480,960562,1009951,797804,981400,327914,702049,520716,356850,465040,65952,447308,601358,420911,861506,536805,166507,339366,222326,217075,291831,194570,679558,1007949,736919,1037235,995479,769559,124061,920824,49988,235805,307600,949576,288620,707541,731227,507211,1009697,264952,1025930,415997,429970,1034676,741378,879335,183412,385849,801873,811654,173548,379532,54571,345146,30324,900366,499279,340409,280429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]