SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972560 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972560 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222376,128365,867014,192093,122007,192700,345910,826596,884452,123123,891084,503427,898379,646684,240847,452232,747893,378746,1017541,551770,170627,801973,456343,5369,852203,574805,414987,620363,477657,956423,1001191,670450,374662,289844,327280,845896,268266,925370,711239,334792,1040684,130042,149346,126174,980420,1023756,372767,844353,936578,195093,968322,380228,335465,547095,192931,170547,922042,144794,645014,430195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]